package com.leedsoft.domain;

import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class SysPmiUserExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public SysPmiUserExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andIDIsNull() {
            addCriterion("ID is null");
            return (Criteria) this;
        }

        public Criteria andIDIsNotNull() {
            addCriterion("ID is not null");
            return (Criteria) this;
        }

        public Criteria andIDEqualTo(Long value) {
            addCriterion("ID =", value, "ID");
            return (Criteria) this;
        }

        public Criteria andIDNotEqualTo(Long value) {
            addCriterion("ID <>", value, "ID");
            return (Criteria) this;
        }

        public Criteria andIDGreaterThan(Long value) {
            addCriterion("ID >", value, "ID");
            return (Criteria) this;
        }

        public Criteria andIDGreaterThanOrEqualTo(Long value) {
            addCriterion("ID >=", value, "ID");
            return (Criteria) this;
        }

        public Criteria andIDLessThan(Long value) {
            addCriterion("ID <", value, "ID");
            return (Criteria) this;
        }

        public Criteria andIDLessThanOrEqualTo(Long value) {
            addCriterion("ID <=", value, "ID");
            return (Criteria) this;
        }

        public Criteria andIDIn(List<Long> values) {
            addCriterion("ID in", values, "ID");
            return (Criteria) this;
        }

        public Criteria andIDNotIn(List<Long> values) {
            addCriterion("ID not in", values, "ID");
            return (Criteria) this;
        }

        public Criteria andIDBetween(Long value1, Long value2) {
            addCriterion("ID between", value1, value2, "ID");
            return (Criteria) this;
        }

        public Criteria andIDNotBetween(Long value1, Long value2) {
            addCriterion("ID not between", value1, value2, "ID");
            return (Criteria) this;
        }

        public Criteria andLOGIN_NAMEIsNull() {
            addCriterion("LOGIN_NAME is null");
            return (Criteria) this;
        }

        public Criteria andLOGIN_NAMEIsNotNull() {
            addCriterion("LOGIN_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andLOGIN_NAMEEqualTo(String value) {
            addCriterion("LOGIN_NAME =", value, "LOGIN_NAME");
            return (Criteria) this;
        }

        public Criteria andLOGIN_NAMENotEqualTo(String value) {
            addCriterion("LOGIN_NAME <>", value, "LOGIN_NAME");
            return (Criteria) this;
        }

        public Criteria andLOGIN_NAMEGreaterThan(String value) {
            addCriterion("LOGIN_NAME >", value, "LOGIN_NAME");
            return (Criteria) this;
        }

        public Criteria andLOGIN_NAMEGreaterThanOrEqualTo(String value) {
            addCriterion("LOGIN_NAME >=", value, "LOGIN_NAME");
            return (Criteria) this;
        }

        public Criteria andLOGIN_NAMELessThan(String value) {
            addCriterion("LOGIN_NAME <", value, "LOGIN_NAME");
            return (Criteria) this;
        }

        public Criteria andLOGIN_NAMELessThanOrEqualTo(String value) {
            addCriterion("LOGIN_NAME <=", value, "LOGIN_NAME");
            return (Criteria) this;
        }

        public Criteria andLOGIN_NAMELike(String value) {
            addCriterion("LOGIN_NAME like", value, "LOGIN_NAME");
            return (Criteria) this;
        }

        public Criteria andLOGIN_NAMENotLike(String value) {
            addCriterion("LOGIN_NAME not like", value, "LOGIN_NAME");
            return (Criteria) this;
        }

        public Criteria andLOGIN_NAMEIn(List<String> values) {
            addCriterion("LOGIN_NAME in", values, "LOGIN_NAME");
            return (Criteria) this;
        }

        public Criteria andLOGIN_NAMENotIn(List<String> values) {
            addCriterion("LOGIN_NAME not in", values, "LOGIN_NAME");
            return (Criteria) this;
        }

        public Criteria andLOGIN_NAMEBetween(String value1, String value2) {
            addCriterion("LOGIN_NAME between", value1, value2, "LOGIN_NAME");
            return (Criteria) this;
        }

        public Criteria andLOGIN_NAMENotBetween(String value1, String value2) {
            addCriterion("LOGIN_NAME not between", value1, value2, "LOGIN_NAME");
            return (Criteria) this;
        }

        public Criteria andPASSWORDIsNull() {
            addCriterion("PASSWORD is null");
            return (Criteria) this;
        }

        public Criteria andPASSWORDIsNotNull() {
            addCriterion("PASSWORD is not null");
            return (Criteria) this;
        }

        public Criteria andPASSWORDEqualTo(String value) {
            addCriterion("PASSWORD =", value, "PASSWORD");
            return (Criteria) this;
        }

        public Criteria andPASSWORDNotEqualTo(String value) {
            addCriterion("PASSWORD <>", value, "PASSWORD");
            return (Criteria) this;
        }

        public Criteria andPASSWORDGreaterThan(String value) {
            addCriterion("PASSWORD >", value, "PASSWORD");
            return (Criteria) this;
        }

        public Criteria andPASSWORDGreaterThanOrEqualTo(String value) {
            addCriterion("PASSWORD >=", value, "PASSWORD");
            return (Criteria) this;
        }

        public Criteria andPASSWORDLessThan(String value) {
            addCriterion("PASSWORD <", value, "PASSWORD");
            return (Criteria) this;
        }

        public Criteria andPASSWORDLessThanOrEqualTo(String value) {
            addCriterion("PASSWORD <=", value, "PASSWORD");
            return (Criteria) this;
        }

        public Criteria andPASSWORDLike(String value) {
            addCriterion("PASSWORD like", value, "PASSWORD");
            return (Criteria) this;
        }

        public Criteria andPASSWORDNotLike(String value) {
            addCriterion("PASSWORD not like", value, "PASSWORD");
            return (Criteria) this;
        }

        public Criteria andPASSWORDIn(List<String> values) {
            addCriterion("PASSWORD in", values, "PASSWORD");
            return (Criteria) this;
        }

        public Criteria andPASSWORDNotIn(List<String> values) {
            addCriterion("PASSWORD not in", values, "PASSWORD");
            return (Criteria) this;
        }

        public Criteria andPASSWORDBetween(String value1, String value2) {
            addCriterion("PASSWORD between", value1, value2, "PASSWORD");
            return (Criteria) this;
        }

        public Criteria andPASSWORDNotBetween(String value1, String value2) {
            addCriterion("PASSWORD not between", value1, value2, "PASSWORD");
            return (Criteria) this;
        }

        public Criteria andNAMEIsNull() {
            addCriterion("NAME is null");
            return (Criteria) this;
        }

        public Criteria andNAMEIsNotNull() {
            addCriterion("NAME is not null");
            return (Criteria) this;
        }

        public Criteria andNAMEEqualTo(String value) {
            addCriterion("NAME =", value, "NAME");
            return (Criteria) this;
        }

        public Criteria andNAMENotEqualTo(String value) {
            addCriterion("NAME <>", value, "NAME");
            return (Criteria) this;
        }

        public Criteria andNAMEGreaterThan(String value) {
            addCriterion("NAME >", value, "NAME");
            return (Criteria) this;
        }

        public Criteria andNAMEGreaterThanOrEqualTo(String value) {
            addCriterion("NAME >=", value, "NAME");
            return (Criteria) this;
        }

        public Criteria andNAMELessThan(String value) {
            addCriterion("NAME <", value, "NAME");
            return (Criteria) this;
        }

        public Criteria andNAMELessThanOrEqualTo(String value) {
            addCriterion("NAME <=", value, "NAME");
            return (Criteria) this;
        }

        public Criteria andNAMELike(String value) {
            addCriterion("NAME like", value, "NAME");
            return (Criteria) this;
        }

        public Criteria andNAMENotLike(String value) {
            addCriterion("NAME not like", value, "NAME");
            return (Criteria) this;
        }

        public Criteria andNAMEIn(List<String> values) {
            addCriterion("NAME in", values, "NAME");
            return (Criteria) this;
        }

        public Criteria andNAMENotIn(List<String> values) {
            addCriterion("NAME not in", values, "NAME");
            return (Criteria) this;
        }

        public Criteria andNAMEBetween(String value1, String value2) {
            addCriterion("NAME between", value1, value2, "NAME");
            return (Criteria) this;
        }

        public Criteria andNAMENotBetween(String value1, String value2) {
            addCriterion("NAME not between", value1, value2, "NAME");
            return (Criteria) this;
        }

        public Criteria andGENDERIsNull() {
            addCriterion("GENDER is null");
            return (Criteria) this;
        }

        public Criteria andGENDERIsNotNull() {
            addCriterion("GENDER is not null");
            return (Criteria) this;
        }

        public Criteria andGENDEREqualTo(String value) {
            addCriterion("GENDER =", value, "GENDER");
            return (Criteria) this;
        }

        public Criteria andGENDERNotEqualTo(String value) {
            addCriterion("GENDER <>", value, "GENDER");
            return (Criteria) this;
        }

        public Criteria andGENDERGreaterThan(String value) {
            addCriterion("GENDER >", value, "GENDER");
            return (Criteria) this;
        }

        public Criteria andGENDERGreaterThanOrEqualTo(String value) {
            addCriterion("GENDER >=", value, "GENDER");
            return (Criteria) this;
        }

        public Criteria andGENDERLessThan(String value) {
            addCriterion("GENDER <", value, "GENDER");
            return (Criteria) this;
        }

        public Criteria andGENDERLessThanOrEqualTo(String value) {
            addCriterion("GENDER <=", value, "GENDER");
            return (Criteria) this;
        }

        public Criteria andGENDERLike(String value) {
            addCriterion("GENDER like", value, "GENDER");
            return (Criteria) this;
        }

        public Criteria andGENDERNotLike(String value) {
            addCriterion("GENDER not like", value, "GENDER");
            return (Criteria) this;
        }

        public Criteria andGENDERIn(List<String> values) {
            addCriterion("GENDER in", values, "GENDER");
            return (Criteria) this;
        }

        public Criteria andGENDERNotIn(List<String> values) {
            addCriterion("GENDER not in", values, "GENDER");
            return (Criteria) this;
        }

        public Criteria andGENDERBetween(String value1, String value2) {
            addCriterion("GENDER between", value1, value2, "GENDER");
            return (Criteria) this;
        }

        public Criteria andGENDERNotBetween(String value1, String value2) {
            addCriterion("GENDER not between", value1, value2, "GENDER");
            return (Criteria) this;
        }

        public Criteria andNICK_NAMEIsNull() {
            addCriterion("NICK_NAME is null");
            return (Criteria) this;
        }

        public Criteria andNICK_NAMEIsNotNull() {
            addCriterion("NICK_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andNICK_NAMEEqualTo(String value) {
            addCriterion("NICK_NAME =", value, "NICK_NAME");
            return (Criteria) this;
        }

        public Criteria andNICK_NAMENotEqualTo(String value) {
            addCriterion("NICK_NAME <>", value, "NICK_NAME");
            return (Criteria) this;
        }

        public Criteria andNICK_NAMEGreaterThan(String value) {
            addCriterion("NICK_NAME >", value, "NICK_NAME");
            return (Criteria) this;
        }

        public Criteria andNICK_NAMEGreaterThanOrEqualTo(String value) {
            addCriterion("NICK_NAME >=", value, "NICK_NAME");
            return (Criteria) this;
        }

        public Criteria andNICK_NAMELessThan(String value) {
            addCriterion("NICK_NAME <", value, "NICK_NAME");
            return (Criteria) this;
        }

        public Criteria andNICK_NAMELessThanOrEqualTo(String value) {
            addCriterion("NICK_NAME <=", value, "NICK_NAME");
            return (Criteria) this;
        }

        public Criteria andNICK_NAMELike(String value) {
            addCriterion("NICK_NAME like", value, "NICK_NAME");
            return (Criteria) this;
        }

        public Criteria andNICK_NAMENotLike(String value) {
            addCriterion("NICK_NAME not like", value, "NICK_NAME");
            return (Criteria) this;
        }

        public Criteria andNICK_NAMEIn(List<String> values) {
            addCriterion("NICK_NAME in", values, "NICK_NAME");
            return (Criteria) this;
        }

        public Criteria andNICK_NAMENotIn(List<String> values) {
            addCriterion("NICK_NAME not in", values, "NICK_NAME");
            return (Criteria) this;
        }

        public Criteria andNICK_NAMEBetween(String value1, String value2) {
            addCriterion("NICK_NAME between", value1, value2, "NICK_NAME");
            return (Criteria) this;
        }

        public Criteria andNICK_NAMENotBetween(String value1, String value2) {
            addCriterion("NICK_NAME not between", value1, value2, "NICK_NAME");
            return (Criteria) this;
        }

        public Criteria andTITLEIsNull() {
            addCriterion("TITLE is null");
            return (Criteria) this;
        }

        public Criteria andTITLEIsNotNull() {
            addCriterion("TITLE is not null");
            return (Criteria) this;
        }

        public Criteria andTITLEEqualTo(String value) {
            addCriterion("TITLE =", value, "TITLE");
            return (Criteria) this;
        }

        public Criteria andTITLENotEqualTo(String value) {
            addCriterion("TITLE <>", value, "TITLE");
            return (Criteria) this;
        }

        public Criteria andTITLEGreaterThan(String value) {
            addCriterion("TITLE >", value, "TITLE");
            return (Criteria) this;
        }

        public Criteria andTITLEGreaterThanOrEqualTo(String value) {
            addCriterion("TITLE >=", value, "TITLE");
            return (Criteria) this;
        }

        public Criteria andTITLELessThan(String value) {
            addCriterion("TITLE <", value, "TITLE");
            return (Criteria) this;
        }

        public Criteria andTITLELessThanOrEqualTo(String value) {
            addCriterion("TITLE <=", value, "TITLE");
            return (Criteria) this;
        }

        public Criteria andTITLELike(String value) {
            addCriterion("TITLE like", value, "TITLE");
            return (Criteria) this;
        }

        public Criteria andTITLENotLike(String value) {
            addCriterion("TITLE not like", value, "TITLE");
            return (Criteria) this;
        }

        public Criteria andTITLEIn(List<String> values) {
            addCriterion("TITLE in", values, "TITLE");
            return (Criteria) this;
        }

        public Criteria andTITLENotIn(List<String> values) {
            addCriterion("TITLE not in", values, "TITLE");
            return (Criteria) this;
        }

        public Criteria andTITLEBetween(String value1, String value2) {
            addCriterion("TITLE between", value1, value2, "TITLE");
            return (Criteria) this;
        }

        public Criteria andTITLENotBetween(String value1, String value2) {
            addCriterion("TITLE not between", value1, value2, "TITLE");
            return (Criteria) this;
        }

        public Criteria andBIRTHDAYIsNull() {
            addCriterion("BIRTHDAY is null");
            return (Criteria) this;
        }

        public Criteria andBIRTHDAYIsNotNull() {
            addCriterion("BIRTHDAY is not null");
            return (Criteria) this;
        }

        public Criteria andBIRTHDAYEqualTo(Date value) {
            addCriterionForJDBCDate("BIRTHDAY =", value, "BIRTHDAY");
            return (Criteria) this;
        }

        public Criteria andBIRTHDAYNotEqualTo(Date value) {
            addCriterionForJDBCDate("BIRTHDAY <>", value, "BIRTHDAY");
            return (Criteria) this;
        }

        public Criteria andBIRTHDAYGreaterThan(Date value) {
            addCriterionForJDBCDate("BIRTHDAY >", value, "BIRTHDAY");
            return (Criteria) this;
        }

        public Criteria andBIRTHDAYGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("BIRTHDAY >=", value, "BIRTHDAY");
            return (Criteria) this;
        }

        public Criteria andBIRTHDAYLessThan(Date value) {
            addCriterionForJDBCDate("BIRTHDAY <", value, "BIRTHDAY");
            return (Criteria) this;
        }

        public Criteria andBIRTHDAYLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("BIRTHDAY <=", value, "BIRTHDAY");
            return (Criteria) this;
        }

        public Criteria andBIRTHDAYIn(List<Date> values) {
            addCriterionForJDBCDate("BIRTHDAY in", values, "BIRTHDAY");
            return (Criteria) this;
        }

        public Criteria andBIRTHDAYNotIn(List<Date> values) {
            addCriterionForJDBCDate("BIRTHDAY not in", values, "BIRTHDAY");
            return (Criteria) this;
        }

        public Criteria andBIRTHDAYBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("BIRTHDAY between", value1, value2, "BIRTHDAY");
            return (Criteria) this;
        }

        public Criteria andBIRTHDAYNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("BIRTHDAY not between", value1, value2, "BIRTHDAY");
            return (Criteria) this;
        }

        public Criteria andOFFICE_ROOMIsNull() {
            addCriterion("OFFICE_ROOM is null");
            return (Criteria) this;
        }

        public Criteria andOFFICE_ROOMIsNotNull() {
            addCriterion("OFFICE_ROOM is not null");
            return (Criteria) this;
        }

        public Criteria andOFFICE_ROOMEqualTo(String value) {
            addCriterion("OFFICE_ROOM =", value, "OFFICE_ROOM");
            return (Criteria) this;
        }

        public Criteria andOFFICE_ROOMNotEqualTo(String value) {
            addCriterion("OFFICE_ROOM <>", value, "OFFICE_ROOM");
            return (Criteria) this;
        }

        public Criteria andOFFICE_ROOMGreaterThan(String value) {
            addCriterion("OFFICE_ROOM >", value, "OFFICE_ROOM");
            return (Criteria) this;
        }

        public Criteria andOFFICE_ROOMGreaterThanOrEqualTo(String value) {
            addCriterion("OFFICE_ROOM >=", value, "OFFICE_ROOM");
            return (Criteria) this;
        }

        public Criteria andOFFICE_ROOMLessThan(String value) {
            addCriterion("OFFICE_ROOM <", value, "OFFICE_ROOM");
            return (Criteria) this;
        }

        public Criteria andOFFICE_ROOMLessThanOrEqualTo(String value) {
            addCriterion("OFFICE_ROOM <=", value, "OFFICE_ROOM");
            return (Criteria) this;
        }

        public Criteria andOFFICE_ROOMLike(String value) {
            addCriterion("OFFICE_ROOM like", value, "OFFICE_ROOM");
            return (Criteria) this;
        }

        public Criteria andOFFICE_ROOMNotLike(String value) {
            addCriterion("OFFICE_ROOM not like", value, "OFFICE_ROOM");
            return (Criteria) this;
        }

        public Criteria andOFFICE_ROOMIn(List<String> values) {
            addCriterion("OFFICE_ROOM in", values, "OFFICE_ROOM");
            return (Criteria) this;
        }

        public Criteria andOFFICE_ROOMNotIn(List<String> values) {
            addCriterion("OFFICE_ROOM not in", values, "OFFICE_ROOM");
            return (Criteria) this;
        }

        public Criteria andOFFICE_ROOMBetween(String value1, String value2) {
            addCriterion("OFFICE_ROOM between", value1, value2, "OFFICE_ROOM");
            return (Criteria) this;
        }

        public Criteria andOFFICE_ROOMNotBetween(String value1, String value2) {
            addCriterion("OFFICE_ROOM not between", value1, value2, "OFFICE_ROOM");
            return (Criteria) this;
        }

        public Criteria andEMAILIsNull() {
            addCriterion("EMAIL is null");
            return (Criteria) this;
        }

        public Criteria andEMAILIsNotNull() {
            addCriterion("EMAIL is not null");
            return (Criteria) this;
        }

        public Criteria andEMAILEqualTo(String value) {
            addCriterion("EMAIL =", value, "EMAIL");
            return (Criteria) this;
        }

        public Criteria andEMAILNotEqualTo(String value) {
            addCriterion("EMAIL <>", value, "EMAIL");
            return (Criteria) this;
        }

        public Criteria andEMAILGreaterThan(String value) {
            addCriterion("EMAIL >", value, "EMAIL");
            return (Criteria) this;
        }

        public Criteria andEMAILGreaterThanOrEqualTo(String value) {
            addCriterion("EMAIL >=", value, "EMAIL");
            return (Criteria) this;
        }

        public Criteria andEMAILLessThan(String value) {
            addCriterion("EMAIL <", value, "EMAIL");
            return (Criteria) this;
        }

        public Criteria andEMAILLessThanOrEqualTo(String value) {
            addCriterion("EMAIL <=", value, "EMAIL");
            return (Criteria) this;
        }

        public Criteria andEMAILLike(String value) {
            addCriterion("EMAIL like", value, "EMAIL");
            return (Criteria) this;
        }

        public Criteria andEMAILNotLike(String value) {
            addCriterion("EMAIL not like", value, "EMAIL");
            return (Criteria) this;
        }

        public Criteria andEMAILIn(List<String> values) {
            addCriterion("EMAIL in", values, "EMAIL");
            return (Criteria) this;
        }

        public Criteria andEMAILNotIn(List<String> values) {
            addCriterion("EMAIL not in", values, "EMAIL");
            return (Criteria) this;
        }

        public Criteria andEMAILBetween(String value1, String value2) {
            addCriterion("EMAIL between", value1, value2, "EMAIL");
            return (Criteria) this;
        }

        public Criteria andEMAILNotBetween(String value1, String value2) {
            addCriterion("EMAIL not between", value1, value2, "EMAIL");
            return (Criteria) this;
        }

        public Criteria andMOBILEIsNull() {
            addCriterion("MOBILE is null");
            return (Criteria) this;
        }

        public Criteria andMOBILEIsNotNull() {
            addCriterion("MOBILE is not null");
            return (Criteria) this;
        }

        public Criteria andMOBILEEqualTo(String value) {
            addCriterion("MOBILE =", value, "MOBILE");
            return (Criteria) this;
        }

        public Criteria andMOBILENotEqualTo(String value) {
            addCriterion("MOBILE <>", value, "MOBILE");
            return (Criteria) this;
        }

        public Criteria andMOBILEGreaterThan(String value) {
            addCriterion("MOBILE >", value, "MOBILE");
            return (Criteria) this;
        }

        public Criteria andMOBILEGreaterThanOrEqualTo(String value) {
            addCriterion("MOBILE >=", value, "MOBILE");
            return (Criteria) this;
        }

        public Criteria andMOBILELessThan(String value) {
            addCriterion("MOBILE <", value, "MOBILE");
            return (Criteria) this;
        }

        public Criteria andMOBILELessThanOrEqualTo(String value) {
            addCriterion("MOBILE <=", value, "MOBILE");
            return (Criteria) this;
        }

        public Criteria andMOBILELike(String value) {
            addCriterion("MOBILE like", value, "MOBILE");
            return (Criteria) this;
        }

        public Criteria andMOBILENotLike(String value) {
            addCriterion("MOBILE not like", value, "MOBILE");
            return (Criteria) this;
        }

        public Criteria andMOBILEIn(List<String> values) {
            addCriterion("MOBILE in", values, "MOBILE");
            return (Criteria) this;
        }

        public Criteria andMOBILENotIn(List<String> values) {
            addCriterion("MOBILE not in", values, "MOBILE");
            return (Criteria) this;
        }

        public Criteria andMOBILEBetween(String value1, String value2) {
            addCriterion("MOBILE between", value1, value2, "MOBILE");
            return (Criteria) this;
        }

        public Criteria andMOBILENotBetween(String value1, String value2) {
            addCriterion("MOBILE not between", value1, value2, "MOBILE");
            return (Criteria) this;
        }

        public Criteria andOFFICE_PHONEIsNull() {
            addCriterion("OFFICE_PHONE is null");
            return (Criteria) this;
        }

        public Criteria andOFFICE_PHONEIsNotNull() {
            addCriterion("OFFICE_PHONE is not null");
            return (Criteria) this;
        }

        public Criteria andOFFICE_PHONEEqualTo(String value) {
            addCriterion("OFFICE_PHONE =", value, "OFFICE_PHONE");
            return (Criteria) this;
        }

        public Criteria andOFFICE_PHONENotEqualTo(String value) {
            addCriterion("OFFICE_PHONE <>", value, "OFFICE_PHONE");
            return (Criteria) this;
        }

        public Criteria andOFFICE_PHONEGreaterThan(String value) {
            addCriterion("OFFICE_PHONE >", value, "OFFICE_PHONE");
            return (Criteria) this;
        }

        public Criteria andOFFICE_PHONEGreaterThanOrEqualTo(String value) {
            addCriterion("OFFICE_PHONE >=", value, "OFFICE_PHONE");
            return (Criteria) this;
        }

        public Criteria andOFFICE_PHONELessThan(String value) {
            addCriterion("OFFICE_PHONE <", value, "OFFICE_PHONE");
            return (Criteria) this;
        }

        public Criteria andOFFICE_PHONELessThanOrEqualTo(String value) {
            addCriterion("OFFICE_PHONE <=", value, "OFFICE_PHONE");
            return (Criteria) this;
        }

        public Criteria andOFFICE_PHONELike(String value) {
            addCriterion("OFFICE_PHONE like", value, "OFFICE_PHONE");
            return (Criteria) this;
        }

        public Criteria andOFFICE_PHONENotLike(String value) {
            addCriterion("OFFICE_PHONE not like", value, "OFFICE_PHONE");
            return (Criteria) this;
        }

        public Criteria andOFFICE_PHONEIn(List<String> values) {
            addCriterion("OFFICE_PHONE in", values, "OFFICE_PHONE");
            return (Criteria) this;
        }

        public Criteria andOFFICE_PHONENotIn(List<String> values) {
            addCriterion("OFFICE_PHONE not in", values, "OFFICE_PHONE");
            return (Criteria) this;
        }

        public Criteria andOFFICE_PHONEBetween(String value1, String value2) {
            addCriterion("OFFICE_PHONE between", value1, value2, "OFFICE_PHONE");
            return (Criteria) this;
        }

        public Criteria andOFFICE_PHONENotBetween(String value1, String value2) {
            addCriterion("OFFICE_PHONE not between", value1, value2, "OFFICE_PHONE");
            return (Criteria) this;
        }

        public Criteria andSTATUSIsNull() {
            addCriterion("STATUS is null");
            return (Criteria) this;
        }

        public Criteria andSTATUSIsNotNull() {
            addCriterion("STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andSTATUSEqualTo(Integer value) {
            addCriterion("STATUS =", value, "STATUS");
            return (Criteria) this;
        }

        public Criteria andSTATUSNotEqualTo(Integer value) {
            addCriterion("STATUS <>", value, "STATUS");
            return (Criteria) this;
        }

        public Criteria andSTATUSGreaterThan(Integer value) {
            addCriterion("STATUS >", value, "STATUS");
            return (Criteria) this;
        }

        public Criteria andSTATUSGreaterThanOrEqualTo(Integer value) {
            addCriterion("STATUS >=", value, "STATUS");
            return (Criteria) this;
        }

        public Criteria andSTATUSLessThan(Integer value) {
            addCriterion("STATUS <", value, "STATUS");
            return (Criteria) this;
        }

        public Criteria andSTATUSLessThanOrEqualTo(Integer value) {
            addCriterion("STATUS <=", value, "STATUS");
            return (Criteria) this;
        }

        public Criteria andSTATUSIn(List<Integer> values) {
            addCriterion("STATUS in", values, "STATUS");
            return (Criteria) this;
        }

        public Criteria andSTATUSNotIn(List<Integer> values) {
            addCriterion("STATUS not in", values, "STATUS");
            return (Criteria) this;
        }

        public Criteria andSTATUSBetween(Integer value1, Integer value2) {
            addCriterion("STATUS between", value1, value2, "STATUS");
            return (Criteria) this;
        }

        public Criteria andSTATUSNotBetween(Integer value1, Integer value2) {
            addCriterion("STATUS not between", value1, value2, "STATUS");
            return (Criteria) this;
        }

        public Criteria andUSER_TYPEIsNull() {
            addCriterion("USER_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andUSER_TYPEIsNotNull() {
            addCriterion("USER_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andUSER_TYPEEqualTo(Integer value) {
            addCriterion("USER_TYPE =", value, "USER_TYPE");
            return (Criteria) this;
        }

        public Criteria andUSER_TYPENotEqualTo(Integer value) {
            addCriterion("USER_TYPE <>", value, "USER_TYPE");
            return (Criteria) this;
        }

        public Criteria andUSER_TYPEGreaterThan(Integer value) {
            addCriterion("USER_TYPE >", value, "USER_TYPE");
            return (Criteria) this;
        }

        public Criteria andUSER_TYPEGreaterThanOrEqualTo(Integer value) {
            addCriterion("USER_TYPE >=", value, "USER_TYPE");
            return (Criteria) this;
        }

        public Criteria andUSER_TYPELessThan(Integer value) {
            addCriterion("USER_TYPE <", value, "USER_TYPE");
            return (Criteria) this;
        }

        public Criteria andUSER_TYPELessThanOrEqualTo(Integer value) {
            addCriterion("USER_TYPE <=", value, "USER_TYPE");
            return (Criteria) this;
        }

        public Criteria andUSER_TYPEIn(List<Integer> values) {
            addCriterion("USER_TYPE in", values, "USER_TYPE");
            return (Criteria) this;
        }

        public Criteria andUSER_TYPENotIn(List<Integer> values) {
            addCriterion("USER_TYPE not in", values, "USER_TYPE");
            return (Criteria) this;
        }

        public Criteria andUSER_TYPEBetween(Integer value1, Integer value2) {
            addCriterion("USER_TYPE between", value1, value2, "USER_TYPE");
            return (Criteria) this;
        }

        public Criteria andUSER_TYPENotBetween(Integer value1, Integer value2) {
            addCriterion("USER_TYPE not between", value1, value2, "USER_TYPE");
            return (Criteria) this;
        }

        public Criteria andHEAD_IMAGEIsNull() {
            addCriterion("HEAD_IMAGE is null");
            return (Criteria) this;
        }

        public Criteria andHEAD_IMAGEIsNotNull() {
            addCriterion("HEAD_IMAGE is not null");
            return (Criteria) this;
        }

        public Criteria andHEAD_IMAGEEqualTo(String value) {
            addCriterion("HEAD_IMAGE =", value, "HEAD_IMAGE");
            return (Criteria) this;
        }

        public Criteria andHEAD_IMAGENotEqualTo(String value) {
            addCriterion("HEAD_IMAGE <>", value, "HEAD_IMAGE");
            return (Criteria) this;
        }

        public Criteria andHEAD_IMAGEGreaterThan(String value) {
            addCriterion("HEAD_IMAGE >", value, "HEAD_IMAGE");
            return (Criteria) this;
        }

        public Criteria andHEAD_IMAGEGreaterThanOrEqualTo(String value) {
            addCriterion("HEAD_IMAGE >=", value, "HEAD_IMAGE");
            return (Criteria) this;
        }

        public Criteria andHEAD_IMAGELessThan(String value) {
            addCriterion("HEAD_IMAGE <", value, "HEAD_IMAGE");
            return (Criteria) this;
        }

        public Criteria andHEAD_IMAGELessThanOrEqualTo(String value) {
            addCriterion("HEAD_IMAGE <=", value, "HEAD_IMAGE");
            return (Criteria) this;
        }

        public Criteria andHEAD_IMAGELike(String value) {
            addCriterion("HEAD_IMAGE like", value, "HEAD_IMAGE");
            return (Criteria) this;
        }

        public Criteria andHEAD_IMAGENotLike(String value) {
            addCriterion("HEAD_IMAGE not like", value, "HEAD_IMAGE");
            return (Criteria) this;
        }

        public Criteria andHEAD_IMAGEIn(List<String> values) {
            addCriterion("HEAD_IMAGE in", values, "HEAD_IMAGE");
            return (Criteria) this;
        }

        public Criteria andHEAD_IMAGENotIn(List<String> values) {
            addCriterion("HEAD_IMAGE not in", values, "HEAD_IMAGE");
            return (Criteria) this;
        }

        public Criteria andHEAD_IMAGEBetween(String value1, String value2) {
            addCriterion("HEAD_IMAGE between", value1, value2, "HEAD_IMAGE");
            return (Criteria) this;
        }

        public Criteria andHEAD_IMAGENotBetween(String value1, String value2) {
            addCriterion("HEAD_IMAGE not between", value1, value2, "HEAD_IMAGE");
            return (Criteria) this;
        }

        public Criteria andNATIONALITYIsNull() {
            addCriterion("NATIONALITY is null");
            return (Criteria) this;
        }

        public Criteria andNATIONALITYIsNotNull() {
            addCriterion("NATIONALITY is not null");
            return (Criteria) this;
        }

        public Criteria andNATIONALITYEqualTo(String value) {
            addCriterion("NATIONALITY =", value, "NATIONALITY");
            return (Criteria) this;
        }

        public Criteria andNATIONALITYNotEqualTo(String value) {
            addCriterion("NATIONALITY <>", value, "NATIONALITY");
            return (Criteria) this;
        }

        public Criteria andNATIONALITYGreaterThan(String value) {
            addCriterion("NATIONALITY >", value, "NATIONALITY");
            return (Criteria) this;
        }

        public Criteria andNATIONALITYGreaterThanOrEqualTo(String value) {
            addCriterion("NATIONALITY >=", value, "NATIONALITY");
            return (Criteria) this;
        }

        public Criteria andNATIONALITYLessThan(String value) {
            addCriterion("NATIONALITY <", value, "NATIONALITY");
            return (Criteria) this;
        }

        public Criteria andNATIONALITYLessThanOrEqualTo(String value) {
            addCriterion("NATIONALITY <=", value, "NATIONALITY");
            return (Criteria) this;
        }

        public Criteria andNATIONALITYLike(String value) {
            addCriterion("NATIONALITY like", value, "NATIONALITY");
            return (Criteria) this;
        }

        public Criteria andNATIONALITYNotLike(String value) {
            addCriterion("NATIONALITY not like", value, "NATIONALITY");
            return (Criteria) this;
        }

        public Criteria andNATIONALITYIn(List<String> values) {
            addCriterion("NATIONALITY in", values, "NATIONALITY");
            return (Criteria) this;
        }

        public Criteria andNATIONALITYNotIn(List<String> values) {
            addCriterion("NATIONALITY not in", values, "NATIONALITY");
            return (Criteria) this;
        }

        public Criteria andNATIONALITYBetween(String value1, String value2) {
            addCriterion("NATIONALITY between", value1, value2, "NATIONALITY");
            return (Criteria) this;
        }

        public Criteria andNATIONALITYNotBetween(String value1, String value2) {
            addCriterion("NATIONALITY not between", value1, value2, "NATIONALITY");
            return (Criteria) this;
        }

        public Criteria andSORT_NUMIsNull() {
            addCriterion("SORT_NUM is null");
            return (Criteria) this;
        }

        public Criteria andSORT_NUMIsNotNull() {
            addCriterion("SORT_NUM is not null");
            return (Criteria) this;
        }

        public Criteria andSORT_NUMEqualTo(Integer value) {
            addCriterion("SORT_NUM =", value, "SORT_NUM");
            return (Criteria) this;
        }

        public Criteria andSORT_NUMNotEqualTo(Integer value) {
            addCriterion("SORT_NUM <>", value, "SORT_NUM");
            return (Criteria) this;
        }

        public Criteria andSORT_NUMGreaterThan(Integer value) {
            addCriterion("SORT_NUM >", value, "SORT_NUM");
            return (Criteria) this;
        }

        public Criteria andSORT_NUMGreaterThanOrEqualTo(Integer value) {
            addCriterion("SORT_NUM >=", value, "SORT_NUM");
            return (Criteria) this;
        }

        public Criteria andSORT_NUMLessThan(Integer value) {
            addCriterion("SORT_NUM <", value, "SORT_NUM");
            return (Criteria) this;
        }

        public Criteria andSORT_NUMLessThanOrEqualTo(Integer value) {
            addCriterion("SORT_NUM <=", value, "SORT_NUM");
            return (Criteria) this;
        }

        public Criteria andSORT_NUMIn(List<Integer> values) {
            addCriterion("SORT_NUM in", values, "SORT_NUM");
            return (Criteria) this;
        }

        public Criteria andSORT_NUMNotIn(List<Integer> values) {
            addCriterion("SORT_NUM not in", values, "SORT_NUM");
            return (Criteria) this;
        }

        public Criteria andSORT_NUMBetween(Integer value1, Integer value2) {
            addCriterion("SORT_NUM between", value1, value2, "SORT_NUM");
            return (Criteria) this;
        }

        public Criteria andSORT_NUMNotBetween(Integer value1, Integer value2) {
            addCriterion("SORT_NUM not between", value1, value2, "SORT_NUM");
            return (Criteria) this;
        }

        public Criteria andGLOBAL_SORT_NUMIsNull() {
            addCriterion("GLOBAL_SORT_NUM is null");
            return (Criteria) this;
        }

        public Criteria andGLOBAL_SORT_NUMIsNotNull() {
            addCriterion("GLOBAL_SORT_NUM is not null");
            return (Criteria) this;
        }

        public Criteria andGLOBAL_SORT_NUMEqualTo(String value) {
            addCriterion("GLOBAL_SORT_NUM =", value, "GLOBAL_SORT_NUM");
            return (Criteria) this;
        }

        public Criteria andGLOBAL_SORT_NUMNotEqualTo(String value) {
            addCriterion("GLOBAL_SORT_NUM <>", value, "GLOBAL_SORT_NUM");
            return (Criteria) this;
        }

        public Criteria andGLOBAL_SORT_NUMGreaterThan(String value) {
            addCriterion("GLOBAL_SORT_NUM >", value, "GLOBAL_SORT_NUM");
            return (Criteria) this;
        }

        public Criteria andGLOBAL_SORT_NUMGreaterThanOrEqualTo(String value) {
            addCriterion("GLOBAL_SORT_NUM >=", value, "GLOBAL_SORT_NUM");
            return (Criteria) this;
        }

        public Criteria andGLOBAL_SORT_NUMLessThan(String value) {
            addCriterion("GLOBAL_SORT_NUM <", value, "GLOBAL_SORT_NUM");
            return (Criteria) this;
        }

        public Criteria andGLOBAL_SORT_NUMLessThanOrEqualTo(String value) {
            addCriterion("GLOBAL_SORT_NUM <=", value, "GLOBAL_SORT_NUM");
            return (Criteria) this;
        }

        public Criteria andGLOBAL_SORT_NUMLike(String value) {
            addCriterion("GLOBAL_SORT_NUM like", value, "GLOBAL_SORT_NUM");
            return (Criteria) this;
        }

        public Criteria andGLOBAL_SORT_NUMNotLike(String value) {
            addCriterion("GLOBAL_SORT_NUM not like", value, "GLOBAL_SORT_NUM");
            return (Criteria) this;
        }

        public Criteria andGLOBAL_SORT_NUMIn(List<String> values) {
            addCriterion("GLOBAL_SORT_NUM in", values, "GLOBAL_SORT_NUM");
            return (Criteria) this;
        }

        public Criteria andGLOBAL_SORT_NUMNotIn(List<String> values) {
            addCriterion("GLOBAL_SORT_NUM not in", values, "GLOBAL_SORT_NUM");
            return (Criteria) this;
        }

        public Criteria andGLOBAL_SORT_NUMBetween(String value1, String value2) {
            addCriterion("GLOBAL_SORT_NUM between", value1, value2, "GLOBAL_SORT_NUM");
            return (Criteria) this;
        }

        public Criteria andGLOBAL_SORT_NUMNotBetween(String value1, String value2) {
            addCriterion("GLOBAL_SORT_NUM not between", value1, value2, "GLOBAL_SORT_NUM");
            return (Criteria) this;
        }

        public Criteria andMEMO1IsNull() {
            addCriterion("MEMO1 is null");
            return (Criteria) this;
        }

        public Criteria andMEMO1IsNotNull() {
            addCriterion("MEMO1 is not null");
            return (Criteria) this;
        }

        public Criteria andMEMO1EqualTo(String value) {
            addCriterion("MEMO1 =", value, "MEMO1");
            return (Criteria) this;
        }

        public Criteria andMEMO1NotEqualTo(String value) {
            addCriterion("MEMO1 <>", value, "MEMO1");
            return (Criteria) this;
        }

        public Criteria andMEMO1GreaterThan(String value) {
            addCriterion("MEMO1 >", value, "MEMO1");
            return (Criteria) this;
        }

        public Criteria andMEMO1GreaterThanOrEqualTo(String value) {
            addCriterion("MEMO1 >=", value, "MEMO1");
            return (Criteria) this;
        }

        public Criteria andMEMO1LessThan(String value) {
            addCriterion("MEMO1 <", value, "MEMO1");
            return (Criteria) this;
        }

        public Criteria andMEMO1LessThanOrEqualTo(String value) {
            addCriterion("MEMO1 <=", value, "MEMO1");
            return (Criteria) this;
        }

        public Criteria andMEMO1Like(String value) {
            addCriterion("MEMO1 like", value, "MEMO1");
            return (Criteria) this;
        }

        public Criteria andMEMO1NotLike(String value) {
            addCriterion("MEMO1 not like", value, "MEMO1");
            return (Criteria) this;
        }

        public Criteria andMEMO1In(List<String> values) {
            addCriterion("MEMO1 in", values, "MEMO1");
            return (Criteria) this;
        }

        public Criteria andMEMO1NotIn(List<String> values) {
            addCriterion("MEMO1 not in", values, "MEMO1");
            return (Criteria) this;
        }

        public Criteria andMEMO1Between(String value1, String value2) {
            addCriterion("MEMO1 between", value1, value2, "MEMO1");
            return (Criteria) this;
        }

        public Criteria andMEMO1NotBetween(String value1, String value2) {
            addCriterion("MEMO1 not between", value1, value2, "MEMO1");
            return (Criteria) this;
        }

        public Criteria andMEMO2IsNull() {
            addCriterion("MEMO2 is null");
            return (Criteria) this;
        }

        public Criteria andMEMO2IsNotNull() {
            addCriterion("MEMO2 is not null");
            return (Criteria) this;
        }

        public Criteria andMEMO2EqualTo(String value) {
            addCriterion("MEMO2 =", value, "MEMO2");
            return (Criteria) this;
        }

        public Criteria andMEMO2NotEqualTo(String value) {
            addCriterion("MEMO2 <>", value, "MEMO2");
            return (Criteria) this;
        }

        public Criteria andMEMO2GreaterThan(String value) {
            addCriterion("MEMO2 >", value, "MEMO2");
            return (Criteria) this;
        }

        public Criteria andMEMO2GreaterThanOrEqualTo(String value) {
            addCriterion("MEMO2 >=", value, "MEMO2");
            return (Criteria) this;
        }

        public Criteria andMEMO2LessThan(String value) {
            addCriterion("MEMO2 <", value, "MEMO2");
            return (Criteria) this;
        }

        public Criteria andMEMO2LessThanOrEqualTo(String value) {
            addCriterion("MEMO2 <=", value, "MEMO2");
            return (Criteria) this;
        }

        public Criteria andMEMO2Like(String value) {
            addCriterion("MEMO2 like", value, "MEMO2");
            return (Criteria) this;
        }

        public Criteria andMEMO2NotLike(String value) {
            addCriterion("MEMO2 not like", value, "MEMO2");
            return (Criteria) this;
        }

        public Criteria andMEMO2In(List<String> values) {
            addCriterion("MEMO2 in", values, "MEMO2");
            return (Criteria) this;
        }

        public Criteria andMEMO2NotIn(List<String> values) {
            addCriterion("MEMO2 not in", values, "MEMO2");
            return (Criteria) this;
        }

        public Criteria andMEMO2Between(String value1, String value2) {
            addCriterion("MEMO2 between", value1, value2, "MEMO2");
            return (Criteria) this;
        }

        public Criteria andMEMO2NotBetween(String value1, String value2) {
            addCriterion("MEMO2 not between", value1, value2, "MEMO2");
            return (Criteria) this;
        }

        public Criteria andFENJIHAOIsNull() {
            addCriterion("FENJIHAO is null");
            return (Criteria) this;
        }

        public Criteria andFENJIHAOIsNotNull() {
            addCriterion("FENJIHAO is not null");
            return (Criteria) this;
        }

        public Criteria andFENJIHAOEqualTo(String value) {
            addCriterion("FENJIHAO =", value, "FENJIHAO");
            return (Criteria) this;
        }

        public Criteria andFENJIHAONotEqualTo(String value) {
            addCriterion("FENJIHAO <>", value, "FENJIHAO");
            return (Criteria) this;
        }

        public Criteria andFENJIHAOGreaterThan(String value) {
            addCriterion("FENJIHAO >", value, "FENJIHAO");
            return (Criteria) this;
        }

        public Criteria andFENJIHAOGreaterThanOrEqualTo(String value) {
            addCriterion("FENJIHAO >=", value, "FENJIHAO");
            return (Criteria) this;
        }

        public Criteria andFENJIHAOLessThan(String value) {
            addCriterion("FENJIHAO <", value, "FENJIHAO");
            return (Criteria) this;
        }

        public Criteria andFENJIHAOLessThanOrEqualTo(String value) {
            addCriterion("FENJIHAO <=", value, "FENJIHAO");
            return (Criteria) this;
        }

        public Criteria andFENJIHAOLike(String value) {
            addCriterion("FENJIHAO like", value, "FENJIHAO");
            return (Criteria) this;
        }

        public Criteria andFENJIHAONotLike(String value) {
            addCriterion("FENJIHAO not like", value, "FENJIHAO");
            return (Criteria) this;
        }

        public Criteria andFENJIHAOIn(List<String> values) {
            addCriterion("FENJIHAO in", values, "FENJIHAO");
            return (Criteria) this;
        }

        public Criteria andFENJIHAONotIn(List<String> values) {
            addCriterion("FENJIHAO not in", values, "FENJIHAO");
            return (Criteria) this;
        }

        public Criteria andFENJIHAOBetween(String value1, String value2) {
            addCriterion("FENJIHAO between", value1, value2, "FENJIHAO");
            return (Criteria) this;
        }

        public Criteria andFENJIHAONotBetween(String value1, String value2) {
            addCriterion("FENJIHAO not between", value1, value2, "FENJIHAO");
            return (Criteria) this;
        }

        public Criteria andTenant_idIsNull() {
            addCriterion("tenant_id is null");
            return (Criteria) this;
        }

        public Criteria andTenant_idIsNotNull() {
            addCriterion("tenant_id is not null");
            return (Criteria) this;
        }

        public Criteria andTenant_idEqualTo(String value) {
            addCriterion("tenant_id =", value, "tenant_id");
            return (Criteria) this;
        }

        public Criteria andTenant_idNotEqualTo(String value) {
            addCriterion("tenant_id <>", value, "tenant_id");
            return (Criteria) this;
        }

        public Criteria andTenant_idGreaterThan(String value) {
            addCriterion("tenant_id >", value, "tenant_id");
            return (Criteria) this;
        }

        public Criteria andTenant_idGreaterThanOrEqualTo(String value) {
            addCriterion("tenant_id >=", value, "tenant_id");
            return (Criteria) this;
        }

        public Criteria andTenant_idLessThan(String value) {
            addCriterion("tenant_id <", value, "tenant_id");
            return (Criteria) this;
        }

        public Criteria andTenant_idLessThanOrEqualTo(String value) {
            addCriterion("tenant_id <=", value, "tenant_id");
            return (Criteria) this;
        }

        public Criteria andTenant_idLike(String value) {
            addCriterion("tenant_id like", value, "tenant_id");
            return (Criteria) this;
        }

        public Criteria andTenant_idNotLike(String value) {
            addCriterion("tenant_id not like", value, "tenant_id");
            return (Criteria) this;
        }

        public Criteria andTenant_idIn(List<String> values) {
            addCriterion("tenant_id in", values, "tenant_id");
            return (Criteria) this;
        }

        public Criteria andTenant_idNotIn(List<String> values) {
            addCriterion("tenant_id not in", values, "tenant_id");
            return (Criteria) this;
        }

        public Criteria andTenant_idBetween(String value1, String value2) {
            addCriterion("tenant_id between", value1, value2, "tenant_id");
            return (Criteria) this;
        }

        public Criteria andTenant_idNotBetween(String value1, String value2) {
            addCriterion("tenant_id not between", value1, value2, "tenant_id");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}